This COVID-19 analysis has two areas of interest. The first being the states of the Untied States and the second being the counties of Oregon. Both sections then explore the areas with the highest number of cases, highest percent of cases per population, highest number of deaths, and highest percent of deaths per population.
Knowing this information is important in several ways. It enables policymakers to tailor measure such as social distancing and stay-at-home orders to specific regions, thereby reducing the overall spread of the virus. Additionally, understanding which areas have been most affected by the pandemic can help identify population groups that may be at higher risk. Finally, tracking trends can help identify areas where the virus is spreading more rapidly and inform decisions around the allocation of resources and policy interventions. Overall, knowing areas with high numbers and percents of COVID-19 cases and deaths is critical in the fight against the pandemic and minimizing its impact on individuals and communities.
As of 2023-03-06, Rhode Island has the highest percent of COVID-19 cases per population, with 43.43%.
Alaska has the second highest percent of COVID-19 cases with 42.02% of the population catching COVID-19, followed by Kentucky (38.46%), North Dakota (37.65%), and Tennessee (35.83%).
As of 2023-03-06, California has the most COVID-19 related deaths, with 103,743 total deaths.
Texas has the second most number of COVID-19 related deaths with 94,163 total deaths, followed by Florida (86,850 total deaths), New York (79,680 total deaths), and Pennsylvania (50,360 total deaths).
Show Code
us_deaths_num_table <-gt(us_deaths_num[1:5,]) %>%fmt_number(columns = deaths,decimals =0 ) %>%fmt_number(columns = population,decimals =0 ) %>%fmt_percent(columns = deaths_per_pop,decimals =2 ) %>%tab_header(title =md("**Highest Number of Deaths**" ),subtitle =paste0("By state as of ", data_list[[4]]) ) %>%cols_label(state =md("**State**" ),population =md("**Population**" ),deaths =md("**Deaths**" ),deaths_per_pop =md("**Percentage**" ) ) %>%style_table() %>% gt::gtsave(filename ="tables/current_us_deaths_num.png" )
As of 2023-03-06, Arizona has the highest percent of COVID-19 deaths per population, with 0.454%.
West Virginia has the second highest percent of COVID-19 deaths with 0.45% of the population dying from COVID-19, followed by Mississippi (0.45%), Alabama (0.439%), and New Mexico (0.433%).
As of 2022-05-13, Multnomah county has the most cases of COVID-19, with 123,906 total cases.
Washington county has the second most number of COVID-19 cases with 91,092 total cases, followed by Marion (70,744 total cases), Clackamas (63,827 total cases), and Lane (59,853 total cases).
Highest Number of Cases
By counties in Oregon as of 2022-05-13
County
Population
Cases
Percentage
Multnomah
812,855
123,906
15%
Washington
601,592
91,092
15%
Marion
347,818
70,744
20%
Clackamas
418,187
63,827
15%
Lane
382,067
59,853
16%
Create Table
or_case_num_table <-gt(or_case_num[1:5,]) %>%fmt_number(columns = cases,decimals =0 ) %>%fmt_number(columns = population,decimals =0 ) %>%fmt_percent(columns = cases_per_pop,decimals =0 ) %>%tab_header(title =md("**Highest Number of Cases**" ),subtitle =paste0("By counties in Oregon as of ", data_list[[4]]) ) %>%cols_label(county =md("**County**" ),population =md("**Population**" ),cases =md("**Cases**" ),cases_per_pop =md("**Percentage**" ) ) %>%tab_style(style =list(cell_fill(color ="#feebe2"),cell_text(color ="#6c464e")),locations =cells_body(columns =everything() ))
As of 2022-05-13, Jefferson county has the highest percent of COVID-19 cases per population, with 29.68%.
Umatilla county has the second highest percent of COVID-19 cases with 28.92% of the population catching COVID-19, followed by Malheur (26.99%), Morrow (25.68%), and Crook (25.23%).
As of 2022-05-13, Multnomah county has the most COVID-19 related deaths, with 1,207 total deaths.
Marion county has the second most number of COVID-19 related deaths with 721 total deaths, followed by Clackamas (632 total deaths), Washington (594 total deaths), and Lane (541 total deaths).
Highest Number of Deaths
By counties in Oregon as of 2022-05-13
County
Population
Deaths
Percentage
Multnomah
812,855
1,207
0.15%
Marion
347,818
721
0.21%
Clackamas
418,187
632
0.15%
Washington
601,592
594
0.10%
Lane
382,067
541
0.14%
Create Table
or_deaths_num_table <-gt(or_deaths_num[1:5,]) %>%fmt_number(columns = deaths,decimals =0 ) %>%fmt_number(columns = population,decimals =0 ) %>%fmt_percent(columns = deaths_per_pop,decimals =2 ) %>%tab_header(title =md("**Highest Number of Deaths**" ),subtitle =paste0("By counties in Oregon as of ", data_list[[4]]) ) %>%cols_label(county =md("**County**" ),population =md("**Population**" ),deaths =md("**Deaths**" ),deaths_per_pop =md("**Percentage**" ) ) %>%tab_style(style =list(cell_fill(color ="#feebe2"),cell_text(color ="#6c464e")),locations =cells_body(columns =everything() ))
As of 2022-05-13, Harney county has the highest percent of COVID-19 deaths per population, with 0.514%.
Josephine county has the second highest percent of COVID-19 deaths with 0.3875% of the population dying from COVID-19, followed by Jefferson (0.3731%), Lake (0.3685%), and Douglas (0.3568%).